SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484061 LIMIT 1 [ RunTime:0.000653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484061 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521623,378560,318179,849451,479850,934256,363009,248471,288561,729636,587070,359734,1039347,114869,143900,808030,50850,663148,480744,323066,966415,350737,805635,777704,722776,1007868,698039,132088,830798,368440,308070,200205,1012029,754071,453419,772842,466419,278661,809791,289436,595483,132887,362449,652178,288420,925440,921332,189076,807427,24022,120899,810856,4711,160318,636253,835186,471233,1006578,423955,432795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]