SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413141 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413141 [ RunTime:0.003417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214211,548832,53928,1016818,430378,121382,717463,583861,928248,224157,620167,786130,427052,778900,252834,956822,418750,479388,118808,334610,372750,764866,853754,718760,303002,571937,1034467,292242,214333,715168,807982,994891,271719,346945,562339,666083,612407,475863,675607,373026,914979,1002381,124637,923280,433462,255036,167652,532129,331598,847667,835803,303916,514800,484042,461533,716039,475339,149080,479325,1040214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]