SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035316 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035316 [ RunTime:0.003357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240790,139942,433991,368450,662073,250876,319269,494297,762602,742125,58784,1020204,189673,355218,953880,974237,224228,1016842,291659,89561,499542,815225,541808,437250,97423,866714,251875,1014461,299084,84476,423291,859705,954349,793455,126709,657328,979454,52552,55280,429125,182030,507380,790137,524183,348886,186298,211877,125801,300224,102336,845205,912655,450901,809344,794149,470560,165735,308114,332245,348253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002645s ]