SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30013 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30013 [ RunTime:0.004445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655040,778068,12988,791875,347682,459793,394797,682190,514716,562182,371360,523393,101774,539329,459789,237952,572733,113320,997828,188031,895354,53859,177818,253019,786851,484615,272393,996046,924923,314225,281195,906570,361924,947260,679492,368041,493063,628036,148618,790386,80236,300267,177084,586718,831869,229880,197048,740673,39867,979314,337262,479751,131801,160750,145837,905360,185161,446785,1030056,105996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]