SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414905 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414905 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264956,997380,803523,745385,821266,257447,233027,319975,1038891,52093,800942,28463,583875,234081,1042548,970076,36016,169285,858681,1003691,289073,470852,898318,879582,674713,958939,679476,68507,39470,295524,623019,879458,4671,1035336,801942,244082,447115,754839,928706,899482,804582,297140,230685,79127,963185,980263,347196,834249,652809,186104,808850,804683,68959,284402,1042918,757343,999994,550332,51509,69310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001489s ]