SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012263 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012263 [ RunTime:0.002811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146867,1016595,229170,906701,432927,131837,443891,372407,535680,236768,288173,207465,940093,244697,628693,848018,9516,798746,697034,224664,203762,158421,525319,34510,56503,266167,88940,959130,839631,309110,650833,973711,893836,537505,849100,539238,124855,583793,637943,200712,63813,733675,968707,79339,421217,582382,885410,411072,578110,941766,869619,804111,800736,491462,201464,846820,889907,619365,104518,715054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001751s ]