SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345540 LIMIT 1 [ RunTime:0.001517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345540 [ RunTime:0.005609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31555,969669,49321,837885,710201,342618,136199,277332,679263,40682,380524,942184,738577,351117,437895,1044075,879052,9290,696401,451153,575872,469552,715968,1022486,486979,655525,878276,95930,704374,440579,702113,889726,429021,41230,207254,73947,86339,779161,2599,418760,844139,608269,81186,733483,772938,338379,467739,582257,562036,643200,248176,679886,943200,516256,427201,869175,620071,411526,1009686,74855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001478s ]