SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893018,506738,55466,799245,536531,693970,879391,133345,290180,667413,344521,879658,104492,1039220,560210,859762,119996,208557,280860,890998,463231,282373,776688,723520,695329,194055,896113,19501,518664,382410,208417,566880,1000341,627916,167460,516836,964184,171671,434590,783215,284039,52444,133528,270397,391113,186406,821643,168939,184301,201478,452932,606734,345713,780614,66057,664761,556507,300640,53728,1027735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]