SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105531 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105531 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631494,416771,797363,457371,1039119,170630,426320,798522,705175,477269,528605,129445,911451,400399,365291,316024,945419,639669,449110,632635,196358,24380,737351,336097,57085,382658,920807,408378,984002,772564,562749,164701,785484,1022912,419755,929066,397090,931048,1047460,743917,225436,250152,817282,554471,316840,244410,397641,21051,256902,46377,684855,1042616,849480,349647,613901,192834,880299,620061,124885,49699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]