SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295011 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295011 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6701,691599,681666,453355,88115,393052,57893,994563,705879,184965,725290,991248,16311,672823,426147,106302,107800,386615,348381,998092,488240,640397,670920,411540,830042,988179,666937,505371,366039,202823,333945,654855,210406,601145,471656,166969,29840,706814,153263,517412,882124,895454,726241,980053,435779,792068,623638,968543,638102,931962,1039164,514301,509416,482569,259648,913346,847905,97495,365381,812505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004046s ]