SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391990 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391990 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982009,963158,541946,375086,244005,501418,553246,763393,108336,626998,544188,401759,161774,53273,62746,1048433,844595,709707,256743,13825,1044551,493624,462585,864132,957655,252130,1014168,123776,269205,124033,815149,341928,1028770,528149,527997,486025,553754,900010,168568,489509,869260,948503,1041117,990640,253927,978685,850167,970900,432864,100210,809253,516342,884197,362478,440308,43076,898935,68678,413949,876509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000808s ]