SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468532 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468532 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678584,928137,97409,712972,1014774,153790,413940,336397,607669,419200,207903,339879,499216,779277,1042508,892293,645534,218304,740140,856439,989898,524753,375551,587898,866873,285905,25424,903150,520753,503642,570826,236338,329720,570758,806390,41676,785130,704555,306179,170222,848932,628849,951569,469334,313600,239808,459137,677163,528705,411149,715381,152639,443175,890118,353782,403780,111220,920173,325387,576236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]