SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504227 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504227 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98030,11368,348536,332559,673971,1035692,541321,512884,239005,1042752,162393,253751,425096,735150,775728,734072,70933,732753,525310,677299,245911,64521,722353,948150,420005,204475,982505,46248,13162,300275,896896,913892,750190,1011293,575483,498917,357373,631927,741119,718132,811366,179325,783058,618591,687131,387917,431299,948406,708576,175558,866796,978277,467289,343320,629438,307205,584245,398564,662414,130124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]