SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457458 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457458 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412007,666336,578657,785597,67526,1045931,741892,170522,666683,571730,372219,557760,68679,382913,690296,869671,211689,9452,612855,885160,74529,768026,219552,285552,595056,133955,166533,940447,110865,650871,359039,399635,339954,132455,520329,654036,272040,272375,198415,210308,247658,176707,278727,566767,975492,638125,698232,452122,341272,45484,265489,83721,211318,671790,16030,92645,1013976,218884,924731,910923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]