SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190401 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190401 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287169,134245,319508,133328,454413,695002,731671,554581,235726,510056,670897,144619,830225,4498,914529,70994,161183,886574,179026,604358,1041090,138824,232817,267102,112722,757097,329808,166866,903309,108955,967892,1043524,479240,975828,584140,187129,344633,990109,218490,695740,624645,484671,875673,715082,666321,580601,152463,23318,719574,172752,733574,424288,820620,241659,109643,703749,960399,712204,965879,951050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]