SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536818 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536818 [ RunTime:0.005347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86508,165729,426127,1045029,871329,957195,698097,897579,153200,460317,796307,369770,444793,780034,37729,242385,422890,500276,745911,64799,137058,398950,54894,672674,234908,383165,375135,411302,1045343,801323,290472,142987,432867,267151,72459,845128,862291,1017929,571875,992027,795079,317182,515276,310223,132915,171263,369857,932074,483039,840820,509931,154516,569107,340060,453399,755749,138377,1020090,958069,752104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]