SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022064 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022064 [ RunTime:0.003097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885044,533042,946309,895800,514424,289695,1029292,167152,694057,1012757,274323,531147,394021,32474,69473,730942,972301,101791,452547,833483,706871,593443,1019294,877148,557400,947028,482120,291143,56265,203960,895217,706856,827806,818403,360364,630507,142451,204538,430386,992635,609796,261159,178736,79602,983363,74881,61067,680049,342360,573757,242797,664795,972340,434542,1044076,295416,510929,114243,856982,183473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]