SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 798801 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 798801 [ RunTime:0.003121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540170,3964,456001,192141,1041430,1008479,697622,545790,684320,274940,911448,542047,284333,877437,707797,673353,440090,189385,196570,507967,766721,171243,552497,989752,176785,275163,505406,399718,952447,12923,456215,8334,713498,97157,842933,847360,915494,126290,772550,833917,946243,624105,1033634,895727,692942,34609,930178,398166,795399,316515,525286,143948,126756,978217,692018,302180,776944,14528,20284,945650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 798801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 798801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]