SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 696183 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 696183 [ RunTime:0.002882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539028,413759,579678,324709,184229,835811,475962,1014076,976346,925966,820622,861018,949387,841724,382342,630421,211943,78137,667657,80806,733630,299399,880313,773633,671110,654419,471772,813737,993818,538553,577283,700788,130363,73382,369893,140763,195227,862020,301818,493709,440150,831586,1039973,1004456,522960,437123,45400,971686,308012,225086,85927,752876,459009,748702,429287,569570,557269,391770,520012,79795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 696183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 696183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004488s ]