SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564429 LIMIT 1 [ RunTime:0.001065s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564429 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149096,476100,351829,830751,145853,809040,18494,142347,473744,292032,468894,332419,962460,120893,1028790,31352,109811,994240,881123,810515,772574,245931,1038087,775357,833051,922889,766318,758771,378663,1043707,596587,252876,877417,836132,125447,518600,377112,735082,404368,614103,505246,577749,731174,92817,511378,627190,1021335,21718,829134,873786,802201,896269,1015574,852322,1044058,205286,391775,835701,583370,761912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]