SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480489 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480489 [ RunTime:0.002459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518600,192254,900334,253705,110740,198112,1007327,950173,518859,332355,197851,542254,513183,907951,101211,921262,13971,901126,1010400,420627,46684,893952,715382,338143,480027,517629,817186,791276,257014,128673,741213,968278,457028,132902,419332,674198,550245,968426,764540,623189,686344,381902,654140,65267,944492,497531,574791,849630,697915,915521,242660,741243,287501,103180,38929,369079,818679,749130,828507,836877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]