SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513214 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513214 [ RunTime:0.001405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399810,167792,675134,827374,723184,458571,744880,997501,16504,51503,935376,1024724,711244,859851,489162,116165,97729,54603,518869,245163,414369,99486,390624,449328,289722,711167,184375,188381,779058,634543,1047981,692421,543114,863305,516241,931312,608239,53352,54846,830947,364985,154221,462862,505994,758459,1008837,208406,287543,800932,559033,180172,879597,557452,149295,881362,266414,442691,1019713,942013,920415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]