SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411498 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411498 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966030,432411,37687,397426,610701,340598,96973,567319,100108,39079,652216,866850,157470,493391,920893,19339,547681,637461,1007434,412408,857179,95320,1044999,1030783,1020613,992956,60027,235033,720508,352486,822775,23021,722223,472477,901449,1040564,595920,1016633,845503,708187,470470,211115,234085,800769,860481,247025,710683,990533,701075,44738,493795,960718,858884,359074,196038,335741,932377,104698,896043,218478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]