SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.016555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508340 LIMIT 1 [ RunTime:0.001311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508340 [ RunTime:0.005294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780510,854606,563232,701331,990396,1042713,799935,350763,883418,34069,353059,774513,290662,929214,690149,749031,249059,94014,767873,203864,793136,31550,499099,108961,478868,88521,950536,470550,521124,324957,482668,781184,533804,1037645,168508,772307,903433,197284,470557,959987,483488,690264,481732,197039,16887,671145,690486,769442,466766,130305,231836,420147,100886,527,806654,720010,657120,274536,885076,375166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002899s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001007s ]