SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102713 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102713 [ RunTime:0.003194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533719,664883,953405,841530,866258,397933,830982,148525,446379,3695,834832,665206,1039290,623157,684325,882936,89314,942967,88667,420134,159330,404015,817128,924804,998386,386389,225967,562409,861696,453247,250519,926215,337074,907619,103997,196697,202857,611348,155660,827645,383902,275587,65349,62194,767328,960542,835617,318099,1031782,244546,942190,401098,316668,744693,96132,730412,87938,55911,583236,773313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000888s ]