SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490203 LIMIT 1 [ RunTime:0.003271s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490203 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770567,380434,257187,516788,514402,786987,47599,769196,851493,914869,1036531,642548,277764,641047,433186,1046394,309906,253963,579973,31439,360972,616074,140768,150530,890885,308500,148933,1016789,278257,891071,783569,909314,821383,303457,500933,726985,108896,1022610,715066,963990,537434,39803,501937,783571,281740,65279,152501,522743,616381,769426,345528,895055,397678,741780,400966,134819,666477,211560,574070,403447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]