SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499403 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499403 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801833,349771,102270,169953,553224,563032,567759,706238,325547,991944,532508,782345,467526,339729,464753,339046,245827,1028835,544323,888368,737760,860928,160347,798859,286236,723980,494839,336210,539491,917113,829419,501506,410197,346559,243351,829954,312344,829994,190630,791392,997595,443789,571946,107566,203881,900701,2052,850503,578471,376744,351191,509350,822649,754458,824194,605954,94585,344102,408017,929294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]