SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291510 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291510 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341946,294087,795018,86328,35676,792156,732433,278322,325636,814916,659038,483484,951356,247483,956274,516317,925914,1041680,348897,814619,136905,812880,988294,918183,38409,137385,143112,641163,383149,1042260,156622,521837,886389,46919,681175,902959,23565,758478,12236,575397,450684,391918,771130,67358,971291,1031803,693882,509188,150783,633670,347934,972582,682595,436557,405923,684224,908259,372998,987867,522810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]