SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298009 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298009 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179040,697183,981422,807610,1029315,283809,7478,974442,661109,953787,272325,422040,32064,675688,259952,480731,333029,920260,789549,50348,530892,693190,330711,562784,407883,426346,935782,623924,735031,886888,198233,749685,185619,35959,137767,430292,490099,839427,684656,996091,331311,514874,585189,588998,854834,481179,336617,247259,584008,600695,310901,69783,301436,640177,19347,954589,716410,394534,754315,272831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]