SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490303 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490303 [ RunTime:0.004663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292734,758972,881717,348591,933942,91437,358402,491723,116497,636494,713002,320742,648455,857312,785608,169803,892771,940708,895273,686998,318393,662753,388788,113312,78556,46963,638998,385649,919202,1041666,482501,142073,599073,550203,836080,95537,608260,855690,1035314,216703,486563,1008138,943419,439994,977242,395776,384256,432446,744520,908396,743814,295780,18985,8582,8091,324770,246445,1009086,377883,1020909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001414s ]