SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341858 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341858 [ RunTime:0.002620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938822,408838,175056,136532,259263,435746,324284,774944,766019,219774,678921,288961,217484,363187,436542,804424,215795,196030,844693,956703,1002327,1028378,732853,840970,119877,852295,19141,195507,428310,37914,887059,155774,154519,256153,565606,583068,356004,671244,980717,924286,953090,871187,199476,137913,673230,246502,995554,605211,109798,879302,942442,768595,86030,697445,66031,385818,185423,1042745,475970,203566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002765s ]