SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 860495 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 860495 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200569,411779,74694,631752,795543,327138,604985,13356,798130,220474,27552,1025063,727168,1001135,917718,429750,49980,911109,353586,1021749,381335,949094,147614,517868,660562,1476,517964,598421,25772,435380,480318,714284,771277,488967,535692,243973,361817,139866,235677,766352,427038,561448,136555,520686,389863,669894,192558,1000716,187259,476920,800565,933733,1040069,7224,215777,984881,395241,574776,821075,982961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 860495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 860495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]