SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602680 LIMIT 1 [ RunTime:0.000832s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602680 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139172,1043068,134983,1008339,7895,28488,226229,711727,331332,135463,396371,343064,230810,273428,248798,285341,17932,937221,589170,383420,314626,281425,219214,469502,944899,816507,238610,96295,421837,398956,566133,538151,345098,385809,815382,26582,812495,913391,1010076,1005340,1041324,240482,648881,485614,724953,1047666,178953,870824,938578,681719,511566,16243,773962,587132,157707,210756,448714,186060,315730,999618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]