SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439323 LIMIT 1 [ RunTime:0.000629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439323 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336962,510592,938279,42246,499162,808338,119717,404775,461174,197024,648407,760906,984022,952038,863535,128255,63618,1027590,768809,795182,851909,895254,665578,553394,951017,249697,559850,38578,588130,515172,362754,935805,906501,855478,823058,1016516,813464,234568,733635,960952,1005060,477267,32165,386609,724761,1048789,762806,771586,612258,239019,284133,862493,536965,165980,383416,176176,73020,764256,668541,538342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]