SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497030 LIMIT 1 [ RunTime:0.001121s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497030 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203744,704482,610328,1022750,426209,354144,154909,513609,799885,996182,321966,665874,499645,273988,279768,462293,444120,795307,735943,280179,13550,152926,913057,75088,1008637,905217,977,802001,450621,356099,40054,354859,553287,149401,106752,437466,303809,141270,441593,248832,253325,950954,898479,514063,726014,608966,369353,826869,753449,269496,310422,182593,697234,441676,343937,361781,846182,147994,1002059,615064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]