SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51011 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51011 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210903,1037825,692364,1030865,105884,671458,313121,745163,193145,577112,135214,53091,564159,302501,624975,942882,368067,216646,27714,646110,1007955,682345,168055,472362,211746,872461,6816,83305,1005376,204732,24108,382788,644350,986140,4136,401307,316814,736600,131883,336320,1034404,237340,633473,1036951,583895,782476,1027091,701617,883079,300668,945711,775013,753713,145438,718136,329960,493785,17912,683431,643861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]