SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396004 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396004 [ RunTime:0.006430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479496,33460,702719,820245,76544,335180,683995,222771,909764,1012613,77486,743916,336233,184375,967202,572950,960075,28312,701041,159989,493648,925312,1035048,216605,620624,855189,234631,970282,377846,248947,295745,392275,139339,296994,191978,1031989,228481,683011,303364,192829,604379,153325,794067,537791,561411,197894,557144,848692,1047624,277854,578693,689811,925954,837920,450663,887047,150205,769813,290808,109773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]