SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525521 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525521 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126556,800516,443873,1024618,642410,709600,1034940,98769,390460,1021288,101384,474644,390465,359593,937071,365701,642592,874862,377374,830639,315184,454193,310519,537453,472363,419691,543881,300645,457893,905570,313720,629983,309826,767759,169348,677102,319388,161612,621622,496109,348743,30452,125972,298072,875468,725190,857115,385389,613772,335658,732220,401945,359670,130869,1032254,235080,797914,837510,835595,844336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]