SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450103 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450103 [ RunTime:0.004929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877282,369874,197755,236833,365018,747626,123991,140359,803696,730223,846919,396036,749489,256722,46998,39498,293472,655109,824123,178407,987210,358233,82789,610119,824945,138180,100680,668708,1004701,838362,69576,372829,827133,497716,319623,296843,828398,795322,683744,478097,116579,833924,548494,367975,318125,751964,265836,476142,151448,706357,813670,211200,420749,4587,909639,864990,42248,535708,365302,768296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000846s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002319s ]