SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404413 LIMIT 1 [ RunTime:0.001549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404413 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588630,675509,698178,735856,511029,650776,149548,600752,320654,505028,36294,646741,947992,309379,1012694,649496,129977,872464,910619,206137,833487,680357,35147,142546,282145,881462,717696,112293,765859,491246,624983,60047,47137,749783,81268,91677,139952,1018062,797128,965837,125633,532637,162460,410438,635290,395274,991440,261450,22890,308086,163592,19943,974094,879386,960362,955277,536044,164078,502532,603511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001727s ]