SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102401 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102401 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444435,413409,758166,490800,997282,147601,314786,405239,345367,180229,404121,563462,486277,592900,41075,90984,1021362,67,458747,713303,712054,127018,725978,61447,747106,481084,545500,1015856,990733,870878,811161,183808,437132,943870,812068,165845,1024326,896722,725298,575522,544042,686609,282988,170081,243735,209100,69644,1008623,290015,583276,46985,217627,37957,591128,283084,352295,264894,181547,554076,248300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]