SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409505 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409505 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902358,871860,485132,338957,977486,961361,1036751,540444,139010,243498,28725,609286,1042433,774014,766058,84703,373217,14134,807326,87358,375182,822851,955113,822738,214626,513561,841413,666124,572570,988263,449634,694429,221626,40714,1031113,233841,737435,699994,174619,96626,892773,965470,669023,206513,403387,598643,867870,523991,500111,159766,1040886,387878,207789,300430,436350,741015,14936,76926,667341,1026168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]