SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200485 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200485 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749632,5307,529840,544865,369389,114133,422840,631888,493274,552308,950201,385014,287580,608506,135648,41644,674342,810521,917026,827626,435463,327582,251585,364390,678631,463971,158613,1016026,985310,221632,903792,850899,143498,346371,757436,829598,943335,990117,518553,116248,890349,517810,372701,630359,699776,1028802,427847,445711,872491,367171,471895,1039747,345057,142140,859302,410570,312874,1001937,889686,450629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200485 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200485 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]