SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687193 LIMIT 1 [ RunTime:0.001089s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687193 [ RunTime:0.002506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744797,939866,810234,269206,289049,348703,790916,100500,68776,1041481,45474,393805,1006409,145735,812380,327524,975936,762404,989342,626849,2200,699731,721999,1032634,52621,983859,312779,475370,169062,141026,459150,540413,433559,813579,1031677,701950,405071,541246,208857,285974,996320,366903,719618,450491,294317,595197,101079,754001,920404,706402,677053,575578,662634,359846,605384,1044989,721647,364167,636163,655805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]