SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580094 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580094 [ RunTime:0.002713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468435,735390,256398,131365,574423,4822,802756,834642,318284,352837,931265,176164,175546,353339,2949,587222,837767,68810,55245,465808,799140,63699,684802,81589,517816,567572,164568,976039,271187,401955,322774,291671,570871,256841,568447,653834,310599,25978,616345,441692,726420,539414,375526,127092,573061,1037237,669880,271004,728577,592420,92550,620996,1016511,653312,741330,894038,27715,907778,260405,1037639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]