SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578703 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578703 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463645,860192,200070,381014,1014862,893723,265048,579422,383216,434904,366948,705091,12950,936268,460233,24730,191103,769129,501442,815689,418472,322427,1022104,68877,228955,725009,680565,36295,264420,915525,777462,1047875,947207,467520,251239,973310,10879,43789,715097,597821,379618,846404,612441,23243,862434,824521,705512,938171,947932,913491,813811,119251,576983,634064,387308,505158,274980,526225,326182,369324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]