SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 968911 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 968911 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449416,1011495,304685,83969,70901,946610,557743,267888,301296,956475,863813,1014356,682627,795089,196833,808101,985859,515122,27572,295820,895599,482047,558199,199154,195056,343709,378365,605860,227337,424722,829644,886812,759202,153351,567302,950371,392697,185226,955076,558900,687062,860744,368182,266747,790748,405154,182414,485413,526601,326806,352769,374167,156030,264571,249840,840683,157119,53058,123826,518213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 968911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 968911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]