SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410958 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410958 [ RunTime:0.003502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383023,740443,28446,898306,225437,42280,827077,898111,619833,31232,499703,518409,519550,100235,667331,870013,851792,260118,750760,722504,53521,155417,944939,847575,153819,189928,111047,319774,626273,198248,577550,385794,112116,107244,301822,305265,695793,475118,706598,299212,799106,192137,293862,582209,147028,642971,920230,701764,728102,152613,371552,614525,401975,264965,605517,320104,1032659,894254,634441,325015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]