SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002575s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442301 LIMIT 1 [ RunTime:0.002144s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442301 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421021,266694,169433,551691,239669,420047,1033083,247686,35974,374492,372948,36998,104519,656504,1008725,481661,461982,1040978,794858,864183,777620,358734,420662,718925,207905,180971,189835,974380,323107,839219,566102,426676,951738,977945,286039,432893,638978,387692,672469,312366,717376,581340,564631,399976,567790,525897,380813,334282,263183,858100,852628,300888,971781,210819,431669,4615,659715,416210,516758,179775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]