SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 773412 LIMIT 1 [ RunTime:0.001465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 773412 [ RunTime:0.007709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813985,296225,942777,695367,761515,977172,265517,582980,33278,15331,934450,622140,92714,80279,136693,800170,277528,320201,315028,466871,233481,435059,906278,968619,866167,174901,1015263,634908,477629,626767,192106,1483,745688,1025885,261794,900145,13879,951248,456922,105535,125366,850789,433439,32958,711621,879720,562694,135939,818809,120946,900206,958445,293317,224748,1025384,815863,461834,937815,939299,645729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 773412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 773412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000812s ]