SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453309 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453309 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257971,11661,415749,458081,557265,397744,269206,259492,27773,68672,346954,961634,844919,212826,916634,123103,351473,182210,60165,294991,910072,659195,173758,735447,28933,984818,238812,314277,946454,1018408,810638,578678,90329,364944,300598,662864,979105,554377,906643,971830,238144,200977,899592,350722,222794,395409,526637,184220,710047,701253,1047857,914110,482581,358516,132604,1029212,309811,324089,173340,311472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]