SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118874 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118874 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228081,413812,851871,348571,578445,357120,572652,507578,106569,458862,277555,313369,364468,925886,294875,129380,317739,1014639,243217,287852,216696,1038177,2774,383139,4470,181587,485508,405713,296608,932353,837950,657944,616229,1009248,837288,435484,884333,746793,896526,764233,722181,228728,449076,84134,587805,959566,1011169,280140,223021,121372,525931,975832,696703,633280,701382,855403,1004367,1024215,441319,896892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118874 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118874 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]