SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524912 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524912 [ RunTime:0.001406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85369,15623,355247,481871,673536,713785,797096,271038,334101,147911,55678,782537,305697,870878,1017179,975411,757260,381279,1022172,872283,383457,164699,673301,196872,179256,735617,199450,462694,278468,25964,976001,546182,552760,579630,500297,548961,308278,351939,820686,1013820,895488,234454,841084,833687,312898,1005074,244812,863602,642367,952842,635294,20768,975414,378677,662717,728647,298297,342933,339062,1005499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]