SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802368 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802368 [ RunTime:0.003441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428564,602748,883880,789544,946469,958704,1027281,920401,1000679,561675,831092,258316,451039,1540,99520,340474,341886,285911,655100,642622,433457,349257,929733,104664,783771,774566,113512,696661,637561,106039,18410,832025,277044,220179,112853,823384,381086,77736,742146,871807,387159,509727,620638,676539,593318,852289,781151,343858,122539,864004,635011,850924,167106,829270,137151,351174,882447,553498,645120,688205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]