SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001809s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564812 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564812 [ RunTime:0.002682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640395,480998,815040,877332,354529,41070,602396,1034833,256840,746580,371882,175113,680481,728443,266152,489297,97522,89375,686318,27131,513519,400087,956231,823230,633120,5505,16295,675180,925378,1032701,488204,887694,266717,190670,552918,661243,512086,328616,733475,242206,435168,513899,885657,189310,489009,183799,755785,317055,451913,635690,61713,623074,770971,978334,167122,378575,375588,309086,913292,514368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]