SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505226 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505226 [ RunTime:0.002760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624594,693881,621488,870746,422334,607529,556383,94677,162064,529002,422009,68249,179227,773316,1037529,729466,909828,769592,558396,674436,264747,312961,30042,258365,261099,717479,4897,430898,665700,982646,288831,435902,812772,600191,958813,799503,144146,827276,269965,99883,256713,914816,837223,400753,334969,421618,707091,357798,747930,713053,732154,477630,293136,974328,135990,846278,286318,1037400,141539,597066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]