SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454046 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454046 [ RunTime:0.002669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437737,63593,580541,630810,445827,673934,436879,588049,273248,653404,990801,844724,248544,452877,76965,846418,793660,1041461,943786,149164,1020343,685289,377902,137365,112341,770401,935052,518439,631600,236392,407815,539103,507901,432274,36678,680831,5778,499526,148519,468607,513931,329099,258834,249446,618976,100196,984973,160570,951362,599863,297920,783747,470939,618139,107443,569515,870452,719988,801019,914310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]