SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003902s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431283 LIMIT 1 [ RunTime:0.003759s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431283 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550068,676439,689846,52988,347585,330455,539334,817163,1003328,289409,623525,26538,744105,287218,63005,513291,940184,545526,749236,113414,651033,42928,992301,830828,855768,17757,166684,404695,138249,360002,372233,676728,783495,487961,810139,550137,227511,1033981,215493,907436,962385,835967,874704,873733,675006,539554,107238,291180,373953,451652,220560,664509,1014985,982339,278744,977639,985582,655261,905820,646989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]