SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406618 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406618 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345677,542099,326829,899458,557045,586071,511990,463701,1022154,310451,171029,405930,401593,474580,724206,186132,978573,146592,756527,293274,481088,114665,326333,261634,541877,831462,926363,126162,312072,603159,673101,861482,579766,966808,142069,991338,284377,92679,578260,259966,812211,731141,137474,175424,332377,69175,319363,951074,554192,1020522,393752,332082,1029278,909510,401848,91355,741579,293433,450765,625630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]