SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386048 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386048 [ RunTime:0.002455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56309,926115,304840,698327,1007386,501335,145939,1038280,982695,693603,813917,491182,61351,973853,67554,807833,998416,372517,193566,220639,433899,394354,28033,418705,449165,711469,460287,162418,125217,698,1040029,298503,243099,193035,543570,142792,975803,291716,266236,950045,126009,340409,1016865,963288,754598,103277,54609,820302,743999,985563,532503,388390,89355,405778,183420,797532,406783,947500,43149,113169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]