SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 607613 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 607613 [ RunTime:0.002958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107825,18031,1022816,433498,513525,966870,665343,209087,582654,986510,345944,111303,506439,63651,71625,862910,626010,226564,38762,669375,532347,454907,810568,204208,1026146,666120,265096,863538,983159,502738,585969,1005818,785166,200695,375189,653787,320451,585746,422760,601455,135125,811758,86396,796076,462578,880246,408115,364557,729035,42840,565133,31438,1016596,1797,971186,328916,334198,466851,619628,5604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 607613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 607613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002528s ]