SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14651 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14651 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553240,428273,112416,210877,566100,333498,389277,838164,399343,563444,508911,75767,13728,1042061,661914,1037282,910985,15268,498452,245602,230053,673499,724167,694704,160743,191221,773314,623625,479925,273839,711879,278707,321669,676105,629241,586982,103811,762955,816916,401597,920878,772896,639820,933837,814708,743203,1001182,364818,345941,443070,117222,1039577,922723,928320,956244,76946,274021,424879,441435,694327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]