SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564029 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564029 [ RunTime:0.003099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671540,489203,35315,518754,602376,433794,142140,316880,536446,279568,271461,536180,991829,479203,483908,506307,500514,682600,1035264,868612,92699,689897,832640,142767,927038,760375,562347,376923,320674,625986,1032523,958488,23768,990514,132226,898318,650218,874944,185449,911936,652369,72125,373226,5779,902929,1000474,591416,157379,230975,803361,31329,276790,457486,130581,813382,888732,815985,740876,48013,262380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]