SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506460 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506460 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433202,946031,824383,842236,9023,1020920,525874,721470,419351,458918,671088,690580,347417,510715,757125,813228,904574,851657,639675,749239,664518,385493,551119,961949,988485,480852,388540,795675,669401,233024,613575,113988,605076,994436,734593,534286,983192,872873,525962,986562,869453,335000,302367,289983,906176,38511,938815,47055,472718,904110,992242,240229,154044,279054,455642,321979,634678,399725,139321,152114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]