SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570712 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570712 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971230,48347,90283,70481,1030312,434604,163286,175847,955241,892042,161232,39051,676940,289791,620203,31010,507379,956775,360824,3809,261824,537183,436956,276675,714560,882941,451773,878585,841049,354932,615264,844115,548558,782257,480771,577542,425129,822653,528706,320191,99819,834764,106294,212064,354973,137011,522676,459621,293685,739941,1024251,159610,802699,877593,494914,115072,517942,932969,466694,560559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]