SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101644 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101644 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390912,913331,667372,497449,499212,175107,572499,898687,736607,1024891,986498,34493,606682,985098,697619,1030041,284214,903855,208223,87117,785967,710674,639169,436677,984935,607100,497864,790818,1005655,182591,1013798,646443,149294,720073,644010,310847,314729,922778,1023116,466753,977828,552571,827057,730046,784852,837103,890095,677442,392151,300689,968231,484207,605309,512752,986515,292511,788483,124968,58876,353567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]