SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486812 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486812 [ RunTime:0.002595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24125,488636,949812,95180,900678,1018611,684478,841480,358018,793046,677031,633153,434874,684432,98235,21086,26585,848672,233292,850296,611414,361082,458675,520167,189987,30115,825671,351641,515936,764093,399439,671137,724576,985347,546515,280959,897118,96561,420138,370649,46556,382308,275452,956838,280297,520153,404915,157829,875288,448406,186241,384719,395680,547086,78320,1043202,793940,157873,617700,932899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]