SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332017 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332017 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443543,776507,949160,181424,525872,529657,185176,78263,718069,940403,229623,970780,439461,207431,930012,425793,949740,956791,518940,329909,731700,197469,473795,872490,316064,667016,742601,1030333,651090,78387,914421,666877,117272,631556,83601,268003,759456,346649,55926,652251,1013240,376466,358143,1505,1033221,362122,152112,470489,664335,311976,197564,1048563,749377,307812,378231,69788,116084,975736,982858,57399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]