SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035450 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035450 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911393,994133,431119,528128,933900,407771,201084,21880,55069,818627,628944,19731,638029,207493,832892,684324,130940,20307,956893,592951,406390,327900,143395,37263,450438,233922,786205,772250,618773,836102,801617,400122,850429,647406,364542,911208,1011501,60574,497059,903335,496712,683172,590987,473586,228887,662076,787500,440823,454066,672336,505137,540161,751972,928343,1042082,582236,761109,319868,974749,90834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]