SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547457 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547457 [ RunTime:0.002990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422283,378274,754661,604355,109059,244741,653358,396117,429350,676910,467995,1031711,811211,1023205,310759,932000,998197,124222,228407,79473,142780,819954,191563,1043501,241526,919865,850777,280971,49233,482637,1030650,504018,468076,753867,956208,927180,970337,510406,278653,772077,231074,612057,908153,622137,77450,610880,415995,208672,923092,578300,440935,68871,451084,842233,96495,621826,835121,454407,599348,110202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001039s ]