SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027875 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027875 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76458,357860,496982,133400,682847,690768,627653,908455,476352,360,705694,495487,196892,640378,985673,137844,257713,48544,15585,168228,320693,115489,645897,337350,534315,999567,512449,473885,963007,508375,982022,731347,991357,454951,512700,212253,923285,685548,438684,647548,37195,905584,556845,532975,1041489,558423,340562,675930,24116,512660,20199,634358,742597,1019895,608691,529066,630984,695789,61047,336758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]