SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002715s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047544 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047544 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610881,194838,244889,761389,234048,608327,185418,89498,67407,119293,150060,140448,744266,669515,421755,106489,994567,912005,805033,85087,800783,952553,284063,198040,891928,1022125,230221,834916,6778,675883,184041,1005362,430545,804141,250626,899565,778964,15092,768219,238570,917919,401779,675301,48042,726016,272505,853951,59001,586391,775141,664193,367010,299103,788081,551928,239802,388691,321775,3723,67539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]