SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400122 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400122 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829676,849639,486221,1007235,492328,492457,382309,111667,846805,412083,1033978,333945,122859,271487,51961,653539,249190,400513,837571,458600,575678,595514,159670,974658,375368,1003953,536925,891184,704268,582473,890738,834381,753838,377069,379271,348441,1043881,656034,789623,446689,875359,898075,398040,885408,679031,129686,158908,717877,293822,500199,629715,557191,679508,145653,964130,122138,558492,205658,457130,449895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]