SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545046 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545046 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001018,559023,372126,731777,681825,762266,501418,587812,198200,6556,42336,680458,793188,977006,939590,725976,570314,729970,465435,249170,54654,515266,57175,975732,981620,839376,564518,169249,274891,944538,257106,921029,506591,1003080,817852,12561,951754,361492,926797,292179,32014,55122,260608,223396,811336,456565,1020436,411613,681380,249277,736810,883272,516346,415442,875101,302429,829677,752462,335728,251334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]