SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440070 LIMIT 1 [ RunTime:0.001096s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440070 [ RunTime:0.002284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219258,591531,170768,385855,348215,859534,132140,871360,692811,418941,333792,801017,434013,201619,775203,247679,1042188,979673,189248,771178,20019,190294,613091,26284,104826,649943,859147,228030,656991,178974,960993,594886,252018,859366,110296,318770,956806,518029,596558,926390,21021,617899,68108,421400,940741,850630,991779,1031728,798878,1040866,587019,840173,910768,321382,946051,345075,535140,487111,939660,164996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001537s ]