SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447180 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447180 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953271,598647,112259,455809,1045420,631504,471829,176858,812935,143569,448729,406042,34481,431422,530284,541444,622713,792833,80398,116884,20388,522827,991350,206422,1010204,434962,582119,852447,838026,702897,145774,870107,566871,9059,1016811,337049,1019299,721409,394254,430057,1030715,631420,586728,594835,484711,694896,561394,25493,1026818,694196,658443,622542,722383,621271,960803,62328,602824,311391,903140,459058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]