SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48309 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48309 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401642,80957,460524,424665,611657,226407,991420,319503,691504,365338,389896,463343,416388,935048,462535,262442,486371,991293,36011,593617,1020583,806707,672717,515462,831689,878886,630542,782894,959233,216775,901273,537098,25996,907733,144097,128911,230863,195585,255911,420501,1018943,118457,914603,8525,522525,1046045,1012503,94663,365644,381788,152892,240270,130380,209174,164062,981741,775292,440737,305182,941142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]