SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001528 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001528 [ RunTime:0.002745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273023,865392,222281,33495,403324,111892,665610,637186,734707,670760,806181,38256,173428,794383,748119,401147,1024363,717689,62288,613370,898150,697661,1038177,825509,6113,113579,415069,139941,855369,985612,324923,51515,410012,818291,427758,1036268,346629,302026,166990,804995,270488,898525,483894,951021,900470,408166,233779,580648,1014227,702005,341599,1010090,778834,29641,697845,10964,339777,701451,524674,37535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]