SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590873 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590873 [ RunTime:0.003064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343683,98456,652753,74837,596597,571738,1017445,246478,441630,796545,195229,906657,728009,919984,240516,1021689,396910,515070,600542,669824,639037,702480,373239,895379,640211,668332,689823,532165,1027990,830203,764564,977264,373934,686105,451297,304846,87505,355645,905229,519649,45087,550648,454044,492417,788742,662804,139393,957068,696122,762613,537073,49228,808176,604736,704154,245598,420386,999606,933267,307659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]