SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410605 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410605 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593370,991174,634414,609031,827559,265699,979203,428820,275368,653630,503318,37230,995316,798085,123996,167179,1035838,516212,457678,505774,614354,818044,198906,605372,851438,1024032,17648,789257,832198,749115,642904,614404,576520,231961,153250,192454,705136,50557,182997,341616,859197,739231,159200,823190,225010,911969,371850,633061,257651,216305,625024,754830,351353,517343,418440,748426,662288,498836,7349,351390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]